// ******************************************************************
// * Copyright(c)  Steven Lu
// * Description   : Schema_PROD_PLAN_ORDER
// * CreateDate    : 2014-06-05 18:30:20
// * Creater       : CodeSmith
// * LastChangeDate: 2014-06-05 18:30:20
// * LastChanger   : 2014-06-05 18:30:20
// * Version Info  : 1.0 For ESOL
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
  	[Serializable]
    public partial class ProdPlanOrderTable : TableInfo
    {
		public const string C_TableName = "PROD_PLAN_ORDER";
		
		public const string C_ID = "ID";
		public const string C_IS_ACTIVE = "IS_ACTIVE";
		public const string C_CREATED_DATE = "CREATED_DATE";
		public const string C_CREATED_BY = "CREATED_BY";
		public const string C_UPDATED_DATE = "UPDATED_DATE";
		public const string C_UPDATED_BY = "UPDATED_BY";
		public const string C_PO_NO = "PO_NO";
		public const string C_SAPP_ITEM_ID = "SAPP_ITEM_ID";
		public const string C_CONTRACT_MODEL = "CONTRACT_MODEL";
		public const string C_PRODUCT_ID = "PRODUCT_ID";
		public const string C_PRODUCT_NAME = "PRODUCT_NAME";
		public const string C_PRODUCT_CODE = "PRODUCT_CODE";
		public const string C_BOM_ID = "BOM_ID";
		public const string C_QTY = "QTY";
		public const string C_DELIVERY_DATE = "DELIVERY_DATE";
		public const string C_INV_TYPE = "INV_TYPE";
		public const string C_LOCATION_CODE = "LOCATION_CODE";
		public const string C_REMARK = "REMARK";
		public const string C_BLUEPRINT_ID = "BLUEPRINT_ID";
		public const string C_PO_USER = "PO_USER";
		public const string C_PO_DATE = "PO_DATE";
		public const string C_ACTUAL_FINISH_DATE = "ACTUAL_FINISH_DATE";
		public const string C_IS_MARK = "IS_MARK";
		public const string C_STATUS = "STATUS";
		public const string C_START_TIME = "START_TIME";
        public const string C_IS_MTRL_HOLD = "IS_MTRL_HOLD";
		public ProdPlanOrderTable()
        {
            _tableName = "PROD_PLAN_ORDER";
        }
		
		protected static ProdPlanOrderTable _current;
        public static ProdPlanOrderTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }
		
		private static void Initial()
        {
            _current = new ProdPlanOrderTable();

            _current.Add(C_ID, new ColumnInfo(C_ID,"Id", true, typeof(string)));
            _current.Add(C_IS_ACTIVE, new ColumnInfo(C_IS_ACTIVE,"IsActive", false, typeof(int)));
            _current.Add(C_CREATED_DATE, new ColumnInfo(C_CREATED_DATE,"CreatedDate", false, typeof(DateTime)));
            _current.Add(C_CREATED_BY, new ColumnInfo(C_CREATED_BY,"CreatedBy", false, typeof(string)));
            _current.Add(C_UPDATED_DATE, new ColumnInfo(C_UPDATED_DATE,"UpdatedDate", false, typeof(DateTime)));
            _current.Add(C_UPDATED_BY, new ColumnInfo(C_UPDATED_BY,"UpdatedBy", false, typeof(string)));
            _current.Add(C_PO_NO, new ColumnInfo(C_PO_NO,"PoNo", false, typeof(string)));
            _current.Add(C_SAPP_ITEM_ID, new ColumnInfo(C_SAPP_ITEM_ID,"SappItemId", false, typeof(string)));
            _current.Add(C_CONTRACT_MODEL, new ColumnInfo(C_CONTRACT_MODEL,"ContractModel", false, typeof(string)));
            _current.Add(C_PRODUCT_ID, new ColumnInfo(C_PRODUCT_ID,"ProductId", false, typeof(string)));
            _current.Add(C_PRODUCT_NAME, new ColumnInfo(C_PRODUCT_NAME,"ProductName", false, typeof(string)));
            _current.Add(C_PRODUCT_CODE, new ColumnInfo(C_PRODUCT_CODE,"ProductCode", false, typeof(string)));
            _current.Add(C_BOM_ID, new ColumnInfo(C_BOM_ID,"BomId", false, typeof(string)));
            _current.Add(C_QTY, new ColumnInfo(C_QTY,"Qty", false, typeof(decimal)));
            _current.Add(C_DELIVERY_DATE, new ColumnInfo(C_DELIVERY_DATE,"DeliveryDate", false, typeof(DateTime)));
            _current.Add(C_INV_TYPE, new ColumnInfo(C_INV_TYPE,"InvType", false, typeof(string)));
            _current.Add(C_LOCATION_CODE, new ColumnInfo(C_LOCATION_CODE,"LocationCode", false, typeof(string)));
            _current.Add(C_REMARK, new ColumnInfo(C_REMARK,"Remark", false, typeof(string)));
            _current.Add(C_BLUEPRINT_ID, new ColumnInfo(C_BLUEPRINT_ID,"BlueprintId", false, typeof(string)));
            _current.Add(C_PO_USER, new ColumnInfo(C_PO_USER,"PoUser", false, typeof(string)));
            _current.Add(C_PO_DATE, new ColumnInfo(C_PO_DATE,"PoDate", false, typeof(DateTime)));
            _current.Add(C_ACTUAL_FINISH_DATE, new ColumnInfo(C_ACTUAL_FINISH_DATE,"ActualFinishDate", false, typeof(DateTime)));
            _current.Add(C_IS_MARK, new ColumnInfo(C_IS_MARK,"IsMark", false, typeof(int)));
            _current.Add(C_STATUS, new ColumnInfo(C_STATUS,"Status", false, typeof(string)));
            _current.Add(C_START_TIME, new ColumnInfo(C_START_TIME,"StartTime", false, typeof(DateTime)));
            _current.Add(C_IS_MTRL_HOLD, new ColumnInfo(C_IS_MTRL_HOLD, "IS_MTRL_HOLD", false, typeof(int)));
		}
		
		public ColumnInfo ID
        {
            get { return this[C_ID]; }
        }
		
		public ColumnInfo IS_ACTIVE
        {
            get { return this[C_IS_ACTIVE]; }
        }
		
		public ColumnInfo CREATED_DATE
        {
            get { return this[C_CREATED_DATE]; }
        }
		
		public ColumnInfo CREATED_BY
        {
            get { return this[C_CREATED_BY]; }
        }
		
		public ColumnInfo UPDATED_DATE
        {
            get { return this[C_UPDATED_DATE]; }
        }
		
		public ColumnInfo UPDATED_BY
        {
            get { return this[C_UPDATED_BY]; }
        }
		
		public ColumnInfo PO_NO
        {
            get { return this[C_PO_NO]; }
        }
		
		public ColumnInfo SAPP_ITEM_ID
        {
            get { return this[C_SAPP_ITEM_ID]; }
        }
		
		public ColumnInfo CONTRACT_MODEL
        {
            get { return this[C_CONTRACT_MODEL]; }
        }
		
		public ColumnInfo PRODUCT_ID
        {
            get { return this[C_PRODUCT_ID]; }
        }
		
		public ColumnInfo PRODUCT_NAME
        {
            get { return this[C_PRODUCT_NAME]; }
        }
		
		public ColumnInfo PRODUCT_CODE
        {
            get { return this[C_PRODUCT_CODE]; }
        }
		
		public ColumnInfo BOM_ID
        {
            get { return this[C_BOM_ID]; }
        }
		
		public ColumnInfo QTY
        {
            get { return this[C_QTY]; }
        }
		
		public ColumnInfo DELIVERY_DATE
        {
            get { return this[C_DELIVERY_DATE]; }
        }
		
		public ColumnInfo INV_TYPE
        {
            get { return this[C_INV_TYPE]; }
        }
		
		public ColumnInfo LOCATION_CODE
        {
            get { return this[C_LOCATION_CODE]; }
        }
		
		public ColumnInfo REMARK
        {
            get { return this[C_REMARK]; }
        }
		
		public ColumnInfo BLUEPRINT_ID
        {
            get { return this[C_BLUEPRINT_ID]; }
        }
		
		public ColumnInfo PO_USER
        {
            get { return this[C_PO_USER]; }
        }
		
		public ColumnInfo PO_DATE
        {
            get { return this[C_PO_DATE]; }
        }
		
		public ColumnInfo ACTUAL_FINISH_DATE
        {
            get { return this[C_ACTUAL_FINISH_DATE]; }
        }
		
		public ColumnInfo IS_MARK
        {
            get { return this[C_IS_MARK]; }
        }
		
		public ColumnInfo STATUS
        {
            get { return this[C_STATUS]; }
        }
		
		public ColumnInfo START_TIME
        {
            get { return this[C_START_TIME]; }
        }

        public ColumnInfo IS_MTRL_HOLD
        {
            get { return this[C_IS_MTRL_HOLD]; }
        }
		
	}
}

